package com.cpj.bsyyzx.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.cpj.bsyyzx.entity.Bed;
import com.cpj.bsyyzx.entity.LifePlan;
import com.cpj.bsyyzx.entity.NurseRecord;
import com.cpj.bsyyzx.entity.StaffManagement;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author 五个臭皮匠
 * @since 2021-04-27
 */
public interface StaffManagementMapper extends BaseMapper<StaffManagement> {
    @Select("SELECT staff_name from staff_management where staff_post=\"医生\" ")
    List<StaffManagement> selectDoctor();

    @Select("SELECT staff_name from staff_management where staff_post=\"护工\" ")
    List<StaffManagement> selectCarer();

    @Select("SELECT staff_name from staff_management where staff_post=\"健康管家\" ")
    List<StaffManagement> selectSteward();

    @Select("SELECT staff_name from staff_management where staff_post=\"护士\" ")
    List<StaffManagement> selectNurse();








    Page pageList(Page page, StaffManagement staffManagement);
    IPage<StaffManagement> selectPageVo(Page<StaffManagement> page, @Param(Constants.WRAPPER) Wrapper<StaffManagement> wrapper);
}
